<%--
    Università degli Studi di Trento
    Facoltà di Scienze MM.FF.NN.
    Corso di Laurea Triennale in Informatica
    A.A. 2011/2012
    Progetto per il corso di Ingegneria del Software
    Autori:
    Bertoldi Lorenzo 155863
    Cattin Cosso Manuel 146607
    Parrello Nicola 145610
    Meneghini Nicola 145961
    Vinciguerra Stefano 145962
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@include file="connessione.jsp"%>


<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <link href="./templateCSS.css" type="text/css" rel="stylesheet" />
        <title>Cert da convalidare</title>
    </head>
    <body>
        <table>
              <tr>
		<!-- <td>Certifica</td> -->
		<td>Matricola</td>
		<td>Nome certificato</td>
		<td>Tipo certificato</td>
                <td>Stampa</td>
                <td>Elimina</td>
	      </tr>
              <%
           /*     Statement st= null;
                  String query="SELECT * "
                      + "FROM certificati c ";
                  st=con.createStatement();
                  ResultSet rs=st.executeQuery(query);*/
            //  while(rs.next()) {
              %>
           <tr>  
	    <td><%/*=rs.getString("user_id")*/%></td>
            <td><%/*=rs.getString("nome_certificato")*/%></td>
            <td><%/*=rs.getString("type")*/%></td>
            <td><form method="post" action="./apri.jsp">
                    <%
                       /* byte[] bytePdf = null;
                        Blob bpdf =  rs.getBlob("blob_pdf");
                        bytePdf = bpdf.getBytes(1,(int)bpdf.length());*/
                    %>
                    <input type="hidden" name="id_cert" value=<%//=rs.getString("id_cert")%>></input>
                    <input type="submit" value="Apri" name="submit"/></input>
                </form> </td>
            <td>
                <form method="post" action="./elimina.jsp">
                    <input type="hidden" name="id_cert" value=<%//=rs.getString("id_cert")%>></input>
                    <input type="submit" value="Elimina" name="submit"/></input>
                </form> 
            </td>
	  </tr>
                <%
                              // } 
            %>
        </table>
    </body>
</html>
